package com.example.model.jdao;

import java.util.List;

import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.example.pojo.Xianlu;


public interface XianLuDao extends CrudRepository<Xianlu, Integer> {
	@Modifying
	@Query("update Xianlu set isqy=:is where id=:id")
	public void update(int is,int id);
	
	@Modifying
	@Query("delete from Xianlu where xlld=?1")
	public void DeleteXianlu(String xlld);
	
	@Modifying
	@Query("UPDATE Ganta SET xlld = '' WHERE xlld = :xlld")
	public void UPDATEGanta(String xlld);
	
	@Modifying
	@Query("UPDATE Ganta SET xlld = :xlld  WHERE gid in (:gids)")
	public void UPDATEGanta(String xlld,List<Integer> gids);
}	
